/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package DBLag;
import ModelLag.OrderArr;
import java.util.ArrayList;
import java.sql.*;
/**
 *
 * @author Ronni
 */
public interface IFDbOrderArr {
    
     /**Finds the next orderID from the MAX value of touple orderID
     * @param 
     * @return int
     */
    public int getNextOrderID();
            /**Finds a Order in the database from a given orderID
     * @param cprNo 
     * @return Employee
     */
    
    public OrderArr findOrderArr(int orderID);
    /**Searches for an OrderArr in the database, with the string "searchString"
     * @param searchString 
     * @return OrderArr
     */    
    public ArrayList<OrderArr> searchOrderArr(String searchString);
     
    /**Retrieves all the OrderArr in the database
     * @param 
     * @return ArrayList<OrderArr>
     */    
    public ArrayList<OrderArr> getAllOrderArr();
    /**inserts the OrderArr in the database
     * @param  
     * @return returnCode
     */        
    /**Retrieves all the OrderArr in the database, AND the associations
     * if boolean is set to true, the objects from the period to -> from are retrieved
     * @param 
     * @return ArrayList<OrderArr>
     */    
    public ArrayList<OrderArr> getEverythingOrderArr(boolean isPeriod, String from, String to);
    /**inserts the OrderArr in the database
     * @param  
     * @return returnCode
     */            
    public int insertOrderArr(OrderArr order);
    /**updates the OrderArr in the database
     * @param orderarr 
     * @return returnCode
     */            
    public int updateOrderArr(OrderArr order);
    /**deletes the OrderArr from the database
     * @param order
     * @return returnCode
     */            
    public int deleteOrderArr(OrderArr order);
    /**builds an OrderArr object from the Resultset retrieved from a query
     * @param results
     * @return Order object
     */            
    
}
